walmart_online_grocery_pickup

Dataset statistics

Number of variables	23
Number of observations	3616
Missing cells	6282
Missing cells (%)	7.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	625.2 KiB
Average record size in memory	177.0 B

Variable types

Numeric	5
Text	6
Categorical	6
Boolean	5
Unsupported	1

Alerts

`Pharmacy_open_to_public_` has constant value ""	Constant
`Fuel_Station_open_to_public_` has constant value ""	Constant
`Online_grocery_pickup` has constant value ""	Constant
`objectid` is highly overall correlated with `businessunit_type_description`	High correlation
`businessunit_number` is highly overall correlated with `bu_num` and 2 other fields	High correlation
`bu_num` is highly overall correlated with `businessunit_number` and 2 other fields	High correlation
`businessunit_banner_description` is highly overall correlated with `businessunit_number` and 2 other fields	High correlation
`businessunit_type_description` is highly overall correlated with `objectid` and 3 other fields	High correlation
`businessunit_isstoreopen` is highly overall correlated with `businessunit_status_code`	High correlation
`businessunit_status_code` is highly overall correlated with `businessunit_isstoreopen`	High correlation
`Grocery_delivery_status` is highly overall correlated with `Online_grocery_pickup_status`	High correlation
`Online_grocery_pickup_status` is highly overall correlated with `Grocery_delivery_status`	High correlation
`businessunit_banner_description` is highly imbalanced (55.3%)	Imbalance
`businessunit_isstoreopen` is highly imbalanced (97.0%)	Imbalance
`businessunit_status_code` is highly imbalanced (55.5%)	Imbalance
`op_status` is highly imbalanced (99.0%)	Imbalance
`Modified_Operating_Hours_` has 3616 (100.0%) missing values	Missing
`Grocery_delivery_service` has 285 (7.9%) missing values	Missing
`Grocery_delivery_status` has 1466 (40.5%) missing values	Missing
`Online_grocery_pickup_status` has 915 (25.3%) missing values	Missing
`X` has unique values	Unique
`objectid` has unique values	Unique
`businessunit_number` has unique values	Unique
`bu_num` has unique values	Unique
`Modified_Operating_Hours_` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-10-22 10:06:48.549054
Analysis finished	2023-10-22 10:06:54.622671
Duration	6.07 seconds
Software version	ydata-profiling vv4.6.0
Download configuration	config.json

X
Real number (ℝ)

UNIQUE

Distinct	3616
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-91.717028

Minimum	-159.36503
Maximum	-65.807268
Zeros	0
Zeros (%)	0.0%
Negative	3616
Negative (%)	100.0%
Memory size	28.4 KiB

Quantile statistics

Minimum	-159.36503
5-th percentile	-119.75631
Q1	-97.333506
median	-88.603161
Q3	-81.707137
95-th percentile	-74.572568
Maximum	-65.807268
Range	93.557757
Interquartile range (IQR)	15.626369

Descriptive statistics

Standard deviation	13.812807
Coefficient of variation (CV)	-0.15060243
Kurtosis	1.2294653
Mean	-91.717028
Median Absolute Deviation (MAD)	7.7241095
Skewness	-1.0507789
Sum	-331648.77
Variance	190.79364
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-94.149054	1	< 0.1%
-83.470749	1	< 0.1%
-80.963031	1	< 0.1%
-77.306007	1	< 0.1%
-122.983962	1	< 0.1%
-80.332788	1	< 0.1%
-97.464612	1	< 0.1%
-82.924041	1	< 0.1%
-119.359391	1	< 0.1%
-79.091184	1	< 0.1%
Other values (3606)	3606	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-159.365025	1	< 0.1%
-158.034591	1	< 0.1%
-158.005571	1	< 0.1%
-157.978362	1	< 0.1%
-157.974452	1	< 0.1%
-157.843233	1	< 0.1%
-157.842705	1	< 0.1%
-156.454892	1	< 0.1%
-155.990922	1	< 0.1%
-151.225228	1	< 0.1%

Value	Count	Frequency (%)
-65.807268	1	< 0.1%
-65.889641	1	< 0.1%
-65.995746	1	< 0.1%
-65.997031	1	< 0.1%
-66.020899	1	< 0.1%
-66.076049	1	< 0.1%
-66.087612	1	< 0.1%
-66.134127	1	< 0.1%
-66.162658	1	< 0.1%
-66.627869	1	< 0.1%

Y
Real number (ℝ)

Distinct	3615
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.549835

Minimum	17.993681
Maximum	64.856378
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	28.4 KiB

Quantile statistics

Minimum	17.993681
5-th percentile	28.121938
Q1	33.001415
median	36.177085
Q3	40.39249
95-th percentile	44.777001
Maximum	64.856378
Range	46.862697
Interquartile range (IQR)	7.3910745

Descriptive statistics

Standard deviation	5.1954421
Coefficient of variation (CV)	0.1421468
Kurtosis	0.64804047
Mean	36.549835
Median Absolute Deviation (MAD)	3.6345995
Skewness	0.015021111
Sum	132164.2
Variance	26.992619
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.473938	2	0.1%
36.3313	1	< 0.1%
40.659918	1	< 0.1%
34.944223	1	< 0.1%
35.580506	1	< 0.1%
46.153048	1	< 0.1%
25.746027	1	< 0.1%
37.695454	1	< 0.1%
40.111341	1	< 0.1%
35.604033	1	< 0.1%
Other values (3605)	3605	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17.993681	1	< 0.1%
17.99736	1	< 0.1%
18.122626	1	< 0.1%
18.141237	1	< 0.1%
18.243301	1	< 0.1%
18.249254	1	< 0.1%
18.380526	1	< 0.1%
18.393823	1	< 0.1%
18.394134	1	< 0.1%
18.411224	1	< 0.1%

Value	Count	Frequency (%)
64.856378	1	< 0.1%
61.309037	1	< 0.1%
61.211988	1	< 0.1%
61.192239	1	< 0.1%
61.140195	1	< 0.1%
60.564278	1	< 0.1%
55.375474	1	< 0.1%
48.818547	1	< 0.1%
48.801658	1	< 0.1%
48.554783	1	< 0.1%

objectid
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	3616
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32379.427

Minimum	29040
Maximum	36706
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	28.4 KiB

Quantile statistics

Minimum	29040
5-th percentile	29357.75
Q1	30462.5
median	32084
Q3	34209.25
95-th percentile	36290
Maximum	36706
Range	7666
Interquartile range (IQR)	3746.75

Descriptive statistics

Standard deviation	2177.0878
Coefficient of variation (CV)	0.06723676
Kurtosis	-1.0862057
Mean	32379.427
Median Absolute Deviation (MAD)	1868.5
Skewness	0.29154817
Sum	1.1708401 × 10⁸
Variance	4739711.2
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29040	1	< 0.1%
33535	1	< 0.1%
33487	1	< 0.1%
33489	1	< 0.1%
33491	1	< 0.1%
33492	1	< 0.1%
33493	1	< 0.1%
33495	1	< 0.1%
33497	1	< 0.1%
33498	1	< 0.1%
Other values (3606)	3606	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
29040	1	< 0.1%
29045	1	< 0.1%
29046	1	< 0.1%
29047	1	< 0.1%
29048	1	< 0.1%
29049	1	< 0.1%
29050	1	< 0.1%
29053	1	< 0.1%
29056	1	< 0.1%
29057	1	< 0.1%

Value	Count	Frequency (%)
36706	1	< 0.1%
36705	1	< 0.1%
36704	1	< 0.1%
36702	1	< 0.1%
36700	1	< 0.1%
36698	1	< 0.1%
36695	1	< 0.1%
36693	1	< 0.1%
36690	1	< 0.1%
36688	1	< 0.1%

businessunit_name
Text

Distinct	3385
Distinct (%)	93.6%
Missing	0
Missing (%)	0.0%
Memory size	28.4 KiB

Length

Max length	42
Median length	32
Mean length	13.925608
Min length	6

Characters and Unicode

Total characters	50355
Distinct characters	70
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3189 ?
Unique (%)	88.2%

Sample

1st row	ROGERS, AR
2nd row	PONCE-PR
3rd row	BROWNSVILLE TX
4th row	LAVALE, MD
5th row	PUEBLO, CO

Value	Count	Frequency (%)
tx	391	4.3%
fl	241	2.7%
ca	219	2.4%
nc	141	1.6%
ga	134	1.5%
la	122	1.3%
oh	117	1.3%
il	117	1.3%
tn	113	1.2%
pa	108	1.2%
Other values (2521)	7353	81.2%

Most occurring characters

Value	Count	Frequency (%)
	5446	10.8%
A	4351	8.6%
N	3504	7.0%
E	3470	6.9%
L	3333	6.6%
O	3184	6.3%
I	2599	5.2%
R	2539	5.0%
T	2487	4.9%
S	2401	4.8%
Other values (60)	17041	33.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	41311	82.0%
Space Separator	5446	10.8%
Other Punctuation	1835	3.6%
Lowercase Letter	587	1.2%
Close Punctuation	489	1.0%
Open Punctuation	489	1.0%
Decimal Number	154	0.3%
Dash Punctuation	43	0.1%
Modifier Symbol	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	4351	10.5%
N	3504	8.5%
E	3470	8.4%
L	3333	8.1%
O	3184	7.7%
I	2599	6.3%
R	2539	6.1%
T	2487	6.0%
S	2401	5.8%
C	1768	4.3%
Other values (16)	11675	28.3%

Lowercase Letter

Value	Count	Frequency (%)
a	71	12.1%
e	64	10.9%
o	60	10.2%
r	53	9.0%
n	51	8.7%
l	48	8.2%
s	33	5.6%
t	30	5.1%
i	28	4.8%
d	23	3.9%
Other values (14)	126	21.5%

Decimal Number

Value	Count	Frequency (%)
1	54	35.1%
2	29	18.8%
0	20	13.0%
3	11	7.1%
7	10	6.5%
6	8	5.2%
5	8	5.2%
4	8	5.2%
8	5	3.2%
9	1	0.6%

Other Punctuation

Value	Count	Frequency (%)
,	1718	93.6%
.	59	3.2%
/	29	1.6%
&	26	1.4%
'	3	0.2%

Space Separator

Value	Count	Frequency (%)
	5446	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	489	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	489	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	43	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	41898	83.2%
Common	8457	16.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	4351	10.4%
N	3504	8.4%
E	3470	8.3%
L	3333	8.0%
O	3184	7.6%
I	2599	6.2%
R	2539	6.1%
T	2487	5.9%
S	2401	5.7%
C	1768	4.2%
Other values (40)	12262	29.3%

Common

Value	Count	Frequency (%)
	5446	64.4%
,	1718	20.3%
)	489	5.8%
(	489	5.8%
.	59	0.7%
1	54	0.6%
-	43	0.5%
/	29	0.3%
2	29	0.3%
&	26	0.3%
Other values (10)	75	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	50355	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	5446	10.8%
A	4351	8.6%
N	3504	7.0%
E	3470	6.9%
L	3333	6.6%
O	3184	6.3%
I	2599	5.2%
R	2539	5.0%
T	2487	4.9%
S	2401	4.8%
Other values (60)	17041	33.8%

businessunit_number
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	3616
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3149.1341

Minimum	1
Maximum	9894
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	28.4 KiB

Quantile statistics

Minimum	1
5-th percentile	272.75
Q1	1329.5
median	2732.5
Q3	4871.25
95-th percentile	6938
Maximum	9894
Range	9893
Interquartile range (IQR)	3541.75

Descriptive statistics

Standard deviation	2164.8546
Coefficient of variation (CV)	0.6874444
Kurtosis	-0.69570333
Mean	3149.1341
Median Absolute Deviation (MAD)	1681.5
Skewness	0.51084009
Sum	11387269
Variance	4686595.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
5893	1	< 0.1%
585	1	< 0.1%
5851	1	< 0.1%
5853	1	< 0.1%
5854	1	< 0.1%
5855	1	< 0.1%
5857	1	< 0.1%
5859	1	< 0.1%
586	1	< 0.1%
Other values (3606)	3606	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
8	1	< 0.1%
12	1	< 0.1%
14	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%

Value	Count	Frequency (%)
9894	1	< 0.1%
8331	1	< 0.1%
8299	1	< 0.1%
8298	1	< 0.1%
8297	1	< 0.1%
8295	1	< 0.1%
8294	1	< 0.1%
8293	1	< 0.1%
8292	1	< 0.1%
8290	1	< 0.1%

businessunit_banner_description
Categorical

HIGH CORRELATION IMBALANCE

Distinct	8
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	28.4 KiB

WM Supercenter	2555
Sam's Club	436
Neighborhood Market	377
Wal-Mart	242
Walmart Fuel Station	3
Other values (3)	3

Length

Max length	26
Median length	14
Mean length	13.649889
Min length	8

Characters and Unicode

Total characters	49358
Distinct characters	42
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	0.1%

Sample

1st row	WM Supercenter
2nd row	WM Supercenter
3rd row	WM Supercenter
4th row	WM Supercenter
5th row	WM Supercenter

Common Values

Value	Count	Frequency (%)
WM Supercenter	2555	70.7%
Sam's Club	436	12.1%
Neighborhood Market	377	10.4%
Wal-Mart	242	6.7%
Walmart Fuel Station	3	0.1%
WM On Campus/RX Facilities	1	< 0.1%
WM ONLINE PICKUP/DELIVERY	1	< 0.1%
STAND ALONE PICKUP	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wm	2557	36.5%
supercenter	2555	36.5%
sam's	436	6.2%
club	436	6.2%
neighborhood	377	5.4%
market	377	5.4%
wal-mart	242	3.5%
fuel	3	< 0.1%
station	3	< 0.1%
walmart	3	< 0.1%
Other values (8)	8	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	8423	17.1%
r	6109	12.4%
	3381	6.8%
t	3184	6.5%
M	3176	6.4%
S	2995	6.1%
u	2995	6.1%
W	2802	5.7%
n	2559	5.2%
p	2556	5.2%
Other values (32)	11178	22.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	35468	71.9%
Uppercase Letter	9829	19.9%
Space Separator	3381	6.8%
Other Punctuation	438	0.9%
Dash Punctuation	242	0.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	3176	32.3%
S	2995	30.5%
W	2802	28.5%
C	439	4.5%
N	381	3.9%
F	4	< 0.1%
I	4	< 0.1%
E	4	< 0.1%
P	4	< 0.1%
O	3	< 0.1%
Other values (10)	17	0.2%

Lowercase Letter

Value	Count	Frequency (%)
e	8423	23.7%
r	6109	17.2%
t	3184	9.0%
u	2995	8.4%
n	2559	7.2%
p	2556	7.2%
c	2556	7.2%
a	1308	3.7%
o	1134	3.2%
b	813	2.3%
Other values (8)	3831	10.8%

Other Punctuation

Value	Count	Frequency (%)
'	436	99.5%
/	2	0.5%

Space Separator

Value	Count	Frequency (%)
	3381	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	242	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	45297	91.8%
Common	4061	8.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	8423	18.6%
r	6109	13.5%
t	3184	7.0%
M	3176	7.0%
S	2995	6.6%
u	2995	6.6%
W	2802	6.2%
n	2559	5.6%
p	2556	5.6%
c	2556	5.6%
Other values (28)	7942	17.5%

Common

Value	Count	Frequency (%)
	3381	83.3%
'	436	10.7%
-	242	6.0%
/	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49358	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	8423	17.1%
r	6109	12.4%
	3381	6.8%
t	3184	6.5%
M	3176	6.4%
S	2995	6.1%
u	2995	6.1%
W	2802	5.7%
n	2559	5.2%
p	2556	5.2%
Other values (32)	11178	22.6%

businessunit_type_description
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	28.4 KiB

Retail	3180
Wholesale	436

Length

Max length	9
Median length	6
Mean length	6.3617257
Min length	6

Characters and Unicode

Total characters	23004
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Retail
2nd row	Retail
3rd row	Retail
4th row	Retail
5th row	Retail

Common Values

Value	Count	Frequency (%)
Retail	3180	87.9%
Wholesale	436	12.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
retail	3180	87.9%
wholesale	436	12.1%

Most occurring characters

Value	Count	Frequency (%)
e	4052	17.6%
l	4052	17.6%
a	3616	15.7%
R	3180	13.8%
t	3180	13.8%
i	3180	13.8%
W	436	1.9%
h	436	1.9%
o	436	1.9%
s	436	1.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	19388	84.3%
Uppercase Letter	3616	15.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4052	20.9%
l	4052	20.9%
a	3616	18.7%
t	3180	16.4%
i	3180	16.4%
h	436	2.2%
o	436	2.2%
s	436	2.2%

Uppercase Letter

Value	Count	Frequency (%)
R	3180	87.9%
W	436	12.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	23004	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4052	17.6%
l	4052	17.6%
a	3616	15.7%
R	3180	13.8%
t	3180	13.8%
i	3180	13.8%
W	436	1.9%
h	436	1.9%
o	436	1.9%
s	436	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	23004	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	4052	17.6%
l	4052	17.6%
a	3616	15.7%
R	3180	13.8%
t	3180	13.8%
i	3180	13.8%
W	436	1.9%
h	436	1.9%
o	436	1.9%
s	436	1.9%

businessunit_isstoreopen
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 KiB

True	3605
False	11

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	3605	99.7%
False	11	0.3%

facilitydetails_location_locati
Text

Distinct	3609
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Memory size	28.4 KiB

Length

Max length	41
Median length	34
Mean length	17.716261
Min length	9

Characters and Unicode

Total characters	64062
Distinct characters	52
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3604 ?
Unique (%)	99.7%

Sample

1st row	2110 W WALNUT ST
2nd row	3305 AVE.BARAMAYA SUITE 100
3rd row	2721 BOCA CHICA BLVD
4th row	12500 COUNTRY CLUB MALL RD
5th row	4080 W NORTHERN AVE

Value	Count	Frequency (%)
rd	691	5.1%
st	549	4.0%
ave	410	3.0%
blvd	410	3.0%
dr	378	2.8%
s	368	2.7%
n	344	2.5%
e	335	2.5%
w	334	2.5%
highway	243	1.8%
Other values (4419)	9500	70.0%

Most occurring characters

Value	Count	Frequency (%)
	9946	15.5%
E	3857	6.0%
R	3403	5.3%
A	3336	5.2%
0	3130	4.9%
1	2875	4.5%
S	2655	4.1%
N	2584	4.0%
T	2454	3.8%
L	2390	3.7%
Other values (42)	27432	42.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	38821	60.6%
Decimal Number	15194	23.7%
Space Separator	9946	15.5%
Other Punctuation	72	0.1%
Dash Punctuation	19	< 0.1%
Lowercase Letter	10	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	3857	9.9%
R	3403	8.8%
A	3336	8.6%
S	2655	6.8%
N	2584	6.7%
T	2454	6.3%
L	2390	6.2%
D	2387	6.1%
O	2064	5.3%
I	1886	4.9%
Other values (17)	11805	30.4%

Decimal Number

Value	Count	Frequency (%)
0	3130	20.6%
1	2875	18.9%
5	1779	11.7%
2	1762	11.6%
3	1313	8.6%
4	1104	7.3%
7	876	5.8%
6	863	5.7%
9	748	4.9%
8	744	4.9%

Lowercase Letter

Value	Count	Frequency (%)
y	2	20.0%
d	2	20.0%
k	1	10.0%
w	1	10.0%
c	1	10.0%
a	1	10.0%
m	1	10.0%
e	1	10.0%

Other Punctuation

Value	Count	Frequency (%)
.	66	91.7%
,	2	2.8%
#	2	2.8%
/	1	1.4%
'	1	1.4%

Space Separator

Value	Count	Frequency (%)
	9946	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	19	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	38831	60.6%
Common	25231	39.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	3857	9.9%
R	3403	8.8%
A	3336	8.6%
S	2655	6.8%
N	2584	6.7%
T	2454	6.3%
L	2390	6.2%
D	2387	6.1%
O	2064	5.3%
I	1886	4.9%
Other values (25)	11815	30.4%

Common

Value	Count	Frequency (%)
	9946	39.4%
0	3130	12.4%
1	2875	11.4%
5	1779	7.1%
2	1762	7.0%
3	1313	5.2%
4	1104	4.4%
7	876	3.5%
6	863	3.4%
9	748	3.0%
Other values (7)	835	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	64061	> 99.9%
None	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	9946	15.5%
E	3857	6.0%
R	3403	5.3%
A	3336	5.2%
0	3130	4.9%
1	2875	4.5%
S	2655	4.1%
N	2584	4.0%
T	2454	3.8%
L	2390	3.7%
Other values (41)	27431	42.8%

None

Value	Count	Frequency (%)
Ñ	1	100.0%

facilitydetails_location_loca_1
Text

Distinct	2073
Distinct (%)	57.3%
Missing	0
Missing (%)	0.0%
Memory size	28.4 KiB

Length

Max length	21
Median length	18
Mean length	8.8279867
Min length	3

Characters and Unicode

Total characters	31922
Distinct characters	28
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1453 ?
Unique (%)	40.2%

Sample

1st row	ROGERS
2nd row	PONCE
3rd row	BROWNSVILLE
4th row	LAVALE
5th row	PUEBLO

Value	Count	Frequency (%)
city	102	2.2%
san	48	1.1%
springs	45	1.0%
beach	42	0.9%
north	34	0.7%
fort	33	0.7%
west	29	0.6%
lake	29	0.6%
las	28	0.6%
saint	27	0.6%
Other values (1999)	4117	90.8%

Most occurring characters

Value	Count	Frequency (%)
A	3056	9.6%
E	3018	9.5%
O	2618	8.2%
L	2564	8.0%
N	2526	7.9%
R	2226	7.0%
I	2027	6.3%
S	1883	5.9%
T	1739	5.4%
C	1076	3.4%
Other values (18)	9189	28.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	31003	97.1%
Space Separator	918	2.9%
Dash Punctuation	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	3056	9.9%
E	3018	9.7%
O	2618	8.4%
L	2564	8.3%
N	2526	8.1%
R	2226	7.2%
I	2027	6.5%
S	1883	6.1%
T	1739	5.6%
C	1076	3.5%
Other values (16)	8270	26.7%

Space Separator

Value	Count	Frequency (%)
	918	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	31003	97.1%
Common	919	2.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	3056	9.9%
E	3018	9.7%
O	2618	8.4%
L	2564	8.3%
N	2526	8.1%
R	2226	7.2%
I	2027	6.5%
S	1883	6.1%
T	1739	5.6%
C	1076	3.5%
Other values (16)	8270	26.7%

Common

Value	Count	Frequency (%)
	918	99.9%
-	1	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	31922	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	3056	9.6%
E	3018	9.5%
O	2618	8.2%
L	2564	8.0%
N	2526	7.9%
R	2226	7.0%
I	2027	6.3%
S	1883	5.9%
T	1739	5.4%
C	1076	3.4%
Other values (18)	9189	28.8%

facilitydetails_location_loca_2
Text

Distinct	1034
Distinct (%)	28.6%
Missing	0
Missing (%)	0.0%
Memory size	28.4 KiB

Length

Max length	28
Median length	25
Mean length	7.3653208
Min length	3

Characters and Unicode

Total characters	26633
Distinct characters	36
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	493 ?
Unique (%)	13.6%

Sample

1st row	BENTON
2nd row	PONCE
3rd row	CAMERON
4th row	ALLEGANY
5th row	PUEBLO

Value	Count	Frequency (%)
st	66	1.6%
san	50	1.2%
orange	46	1.1%
jefferson	45	1.1%
washington	43	1.1%
maricopa	41	1.0%
dallas	40	1.0%
harris	37	0.9%
clark	36	0.9%
city	35	0.9%
Other values (1051)	3596	89.1%

Most occurring characters

Value	Count	Frequency (%)
A	3043	11.4%
E	2492	9.4%
O	2228	8.4%
N	2179	8.2%
R	1969	7.4%
L	1809	6.8%
S	1614	6.1%
I	1454	5.5%
T	1253	4.7%
C	995	3.7%
Other values (26)	7597	28.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	26123	98.1%
Space Separator	420	1.6%
Other Punctuation	70	0.3%
Dash Punctuation	13	< 0.1%
Lowercase Letter	7	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	3043	11.6%
E	2492	9.5%
O	2228	8.5%
N	2179	8.3%
R	1969	7.5%
L	1809	6.9%
S	1614	6.2%
I	1454	5.6%
T	1253	4.8%
C	995	3.8%
Other values (16)	7087	27.1%

Lowercase Letter

Value	Count	Frequency (%)
e	2	28.6%
a	1	14.3%
w	1	14.3%
r	1	14.3%
n	1	14.3%
c	1	14.3%

Other Punctuation

Value	Count	Frequency (%)
.	66	94.3%
'	4	5.7%

Space Separator

Value	Count	Frequency (%)
	420	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	13	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	26130	98.1%
Common	503	1.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	3043	11.6%
E	2492	9.5%
O	2228	8.5%
N	2179	8.3%
R	1969	7.5%
L	1809	6.9%
S	1614	6.2%
I	1454	5.6%
T	1253	4.8%
C	995	3.8%
Other values (22)	7094	27.1%

Common

Value	Count	Frequency (%)
	420	83.5%
.	66	13.1%
-	13	2.6%
'	4	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	26633	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	3043	11.4%
E	2492	9.4%
O	2228	8.4%
N	2179	8.2%
R	1969	7.4%
L	1809	6.8%
S	1614	6.1%
I	1454	5.5%
T	1253	4.7%
C	995	3.7%
Other values (26)	7597	28.5%

facilitydetails_location_loca_3
Text

Distinct	52
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Memory size	28.4 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	7232
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AR
2nd row	PR
3rd row	TX
4th row	MD
5th row	CO

Value	Count	Frequency (%)
tx	400	11.1%
fl	250	6.9%
ca	222	6.1%
nc	145	4.0%
ga	135	3.7%
oh	120	3.3%
il	120	3.3%
tn	116	3.2%
va	110	3.0%
pa	109	3.0%
Other values (42)	1889	52.2%

Most occurring characters

Value	Count	Frequency (%)
A	1082	15.0%
N	663	9.2%
T	585	8.1%
L	574	7.9%
C	556	7.7%
M	475	6.6%
O	440	6.1%
I	430	5.9%
X	400	5.5%
F	250	3.5%
Other values (14)	1777	24.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7232	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1082	15.0%
N	663	9.2%
T	585	8.1%
L	574	7.9%
C	556	7.7%
M	475	6.6%
O	440	6.1%
I	430	5.9%
X	400	5.5%
F	250	3.5%
Other values (14)	1777	24.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7232	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1082	15.0%
N	663	9.2%
T	585	8.1%
L	574	7.9%
C	556	7.7%
M	475	6.6%
O	440	6.1%
I	430	5.9%
X	400	5.5%
F	250	3.5%
Other values (14)	1777	24.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7232	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1082	15.0%
N	663	9.2%
T	585	8.1%
L	574	7.9%
C	556	7.7%
M	475	6.6%
O	440	6.1%
I	430	5.9%
X	400	5.5%
F	250	3.5%
Other values (14)	1777	24.6%

facilitydetails_location_loca_8
Text

Distinct	3572
Distinct (%)	98.8%
Missing	0
Missing (%)	0.0%
Memory size	28.4 KiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	36160
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3528 ?
Unique (%)	97.6%

Sample

1st row	72756-3246
2nd row	00728-0000
3rd row	78521-3501
4th row	21502-7553
5th row	81005-3503

Value	Count	Frequency (%)
27407-2600	2	0.1%
39402-8854	2	0.1%
23602-4311	2	0.1%
37923-3115	2	0.1%
29910-7621	2	0.1%
70058-3405	2	0.1%
21801-2143	2	0.1%
63303-3526	2	0.1%
51501-7672	2	0.1%
29621-1344	2	0.1%
Other values (3562)	3596	99.4%

Most occurring characters

Value	Count	Frequency (%)
0	4738	13.1%
1	3758	10.4%
3	3650	10.1%
2	3631	10.0%
-	3616	10.0%
4	3171	8.8%
7	3036	8.4%
5	3025	8.4%
6	2802	7.7%
8	2496	6.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	32544	90.0%
Dash Punctuation	3616	10.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4738	14.6%
1	3758	11.5%
3	3650	11.2%
2	3631	11.2%
4	3171	9.7%
7	3036	9.3%
5	3025	9.3%
6	2802	8.6%
8	2496	7.7%
9	2237	6.9%

Dash Punctuation

Value	Count	Frequency (%)
-	3616	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	36160	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4738	13.1%
1	3758	10.4%
3	3650	10.1%
2	3631	10.0%
-	3616	10.0%
4	3171	8.8%
7	3036	8.4%
5	3025	8.4%
6	2802	7.7%
8	2496	6.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36160	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4738	13.1%
1	3758	10.4%
3	3650	10.1%
2	3631	10.0%
-	3616	10.0%
4	3171	8.8%
7	3036	8.4%
5	3025	8.4%
6	2802	7.7%
8	2496	6.9%

businessunit_status_code
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	28.4 KiB

5	1857
2	1746
6	11
4	1
3	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3616
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	5
2nd row	5
3rd row	5
4th row	5
5th row	5

Common Values

Value	Count	Frequency (%)
5	1857	51.4%
2	1746	48.3%
6	11	0.3%
4	1	< 0.1%
3	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5	1857	51.4%
2	1746	48.3%
6	11	0.3%
4	1	< 0.1%
3	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
5	1857	51.4%
2	1746	48.3%
6	11	0.3%
4	1	< 0.1%
3	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3616	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
5	1857	51.4%
2	1746	48.3%
6	11	0.3%
4	1	< 0.1%
3	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	3616	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
5	1857	51.4%
2	1746	48.3%
6	11	0.3%
4	1	< 0.1%
3	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3616	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
5	1857	51.4%
2	1746	48.3%
6	11	0.3%
4	1	< 0.1%
3	1	< 0.1%

op_status
Categorical

IMBALANCE

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	28.4 KiB

Open	3613
Closed	3

Length

Max length	6
Median length	4
Mean length	4.0016593
Min length	4

Characters and Unicode

Total characters	14470
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Open
2nd row	Open
3rd row	Open
4th row	Open
5th row	Open

Common Values

Value	Count	Frequency (%)
Open	3613	99.9%
Closed	3	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
open	3613	99.9%
closed	3	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	3616	25.0%
O	3613	25.0%
p	3613	25.0%
n	3613	25.0%
C	3	< 0.1%
l	3	< 0.1%
o	3	< 0.1%
s	3	< 0.1%
d	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10854	75.0%
Uppercase Letter	3616	25.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	3616	33.3%
p	3613	33.3%
n	3613	33.3%
l	3	< 0.1%
o	3	< 0.1%
s	3	< 0.1%
d	3	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
O	3613	99.9%
C	3	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14470	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	3616	25.0%
O	3613	25.0%
p	3613	25.0%
n	3613	25.0%
C	3	< 0.1%
l	3	< 0.1%
o	3	< 0.1%
s	3	< 0.1%
d	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14470	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	3616	25.0%
O	3613	25.0%
p	3613	25.0%
n	3613	25.0%
C	3	< 0.1%
l	3	< 0.1%
o	3	< 0.1%
s	3	< 0.1%
d	3	< 0.1%

Modified_Operating_Hours_
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	3616
Missing (%)	100.0%
Memory size	28.4 KiB

Pharmacy_open_to_public_
Boolean

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 KiB

True	3616

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	3616	100.0%

Fuel_Station_open_to_public_
Boolean

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 KiB

True	3616

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	3616	100.0%

bu_num
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	3616
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3149.1341

Minimum	1
Maximum	9894
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	28.4 KiB

Quantile statistics

Minimum	1
5-th percentile	272.75
Q1	1329.5
median	2732.5
Q3	4871.25
95-th percentile	6938
Maximum	9894
Range	9893
Interquartile range (IQR)	3541.75

Descriptive statistics

Standard deviation	2164.8546
Coefficient of variation (CV)	0.6874444
Kurtosis	-0.69570333
Mean	3149.1341
Median Absolute Deviation (MAD)	1681.5
Skewness	0.51084009
Sum	11387269
Variance	4686595.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
5893	1	< 0.1%
585	1	< 0.1%
5851	1	< 0.1%
5853	1	< 0.1%
5854	1	< 0.1%
5855	1	< 0.1%
5857	1	< 0.1%
5859	1	< 0.1%
586	1	< 0.1%
Other values (3606)	3606	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
8	1	< 0.1%
12	1	< 0.1%
14	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%

Value	Count	Frequency (%)
9894	1	< 0.1%
8331	1	< 0.1%
8299	1	< 0.1%
8298	1	< 0.1%
8297	1	< 0.1%
8295	1	< 0.1%
8294	1	< 0.1%
8293	1	< 0.1%
8292	1	< 0.1%
8290	1	< 0.1%

Grocery_delivery_service
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	285
Missing (%)	7.9%
Memory size	7.2 KiB

False	1738
True	1593
(Missing)	285

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1738	48.1%
True	1593	44.1%
(Missing)	285	7.9%

Grocery_delivery_status
Categorical

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	0.1%
Missing	1466
Missing (%)	40.5%
Memory size	28.4 KiB

Available	1874
Not Available	276

Length

Max length	13
Median length	9
Mean length	9.5134884
Min length	9

Characters and Unicode

Total characters	20454
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Available
2nd row	Available
3rd row	Available
4th row	Available
5th row	Available

Common Values

Value	Count	Frequency (%)
Available	1874	51.8%
Not Available	276	7.6%
(Missing)	1466	40.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
available	2150	88.6%
not	276	11.4%

Most occurring characters

Value	Count	Frequency (%)
a	4300	21.0%
l	4300	21.0%
A	2150	10.5%
v	2150	10.5%
i	2150	10.5%
b	2150	10.5%
e	2150	10.5%
N	276	1.3%
o	276	1.3%
t	276	1.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	17752	86.8%
Uppercase Letter	2426	11.9%
Space Separator	276	1.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	4300	24.2%
l	4300	24.2%
v	2150	12.1%
i	2150	12.1%
b	2150	12.1%
e	2150	12.1%
o	276	1.6%
t	276	1.6%

Uppercase Letter

Value	Count	Frequency (%)
A	2150	88.6%
N	276	11.4%

Space Separator

Value	Count	Frequency (%)
	276	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	20178	98.7%
Common	276	1.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	4300	21.3%
l	4300	21.3%
A	2150	10.7%
v	2150	10.7%
i	2150	10.7%
b	2150	10.7%
e	2150	10.7%
N	276	1.4%
o	276	1.4%
t	276	1.4%

Common

Value	Count	Frequency (%)
	276	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20454	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	4300	21.0%
l	4300	21.0%
A	2150	10.5%
v	2150	10.5%
i	2150	10.5%
b	2150	10.5%
e	2150	10.5%
N	276	1.3%
o	276	1.3%
t	276	1.3%

Online_grocery_pickup
Boolean

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 KiB

True	3616

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	3616	100.0%

Online_grocery_pickup_status
Categorical

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	0.1%
Missing	915
Missing (%)	25.3%
Memory size	28.4 KiB

Available	2361
Not Available	340

Length

Max length	13
Median length	9
Mean length	9.5035172
Min length	9

Characters and Unicode

Total characters	25669
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Available
2nd row	Available
3rd row	Available
4th row	Available
5th row	Available

Common Values

Value	Count	Frequency (%)
Available	2361	65.3%
Not Available	340	9.4%
(Missing)	915	25.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
available	2701	88.8%
not	340	11.2%

Most occurring characters

Value	Count	Frequency (%)
a	5402	21.0%
l	5402	21.0%
A	2701	10.5%
v	2701	10.5%
i	2701	10.5%
b	2701	10.5%
e	2701	10.5%
N	340	1.3%
o	340	1.3%
t	340	1.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	22288	86.8%
Uppercase Letter	3041	11.8%
Space Separator	340	1.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	5402	24.2%
l	5402	24.2%
v	2701	12.1%
i	2701	12.1%
b	2701	12.1%
e	2701	12.1%
o	340	1.5%
t	340	1.5%

Uppercase Letter

Value	Count	Frequency (%)
A	2701	88.8%
N	340	11.2%

Space Separator

Value	Count	Frequency (%)
	340	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	25329	98.7%
Common	340	1.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	5402	21.3%
l	5402	21.3%
A	2701	10.7%
v	2701	10.7%
i	2701	10.7%
b	2701	10.7%
e	2701	10.7%
N	340	1.3%
o	340	1.3%
t	340	1.3%

Common

Value	Count	Frequency (%)
	340	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25669	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	5402	21.0%
l	5402	21.0%
A	2701	10.5%
v	2701	10.5%
i	2701	10.5%
b	2701	10.5%
e	2701	10.5%
N	340	1.3%
o	340	1.3%
t	340	1.3%

Auto

Heatmap
Table

	X	Y	objectid	businessunit_number	bu_num	businessunit_banner_description	businessunit_type_description	businessunit_isstoreopen	businessunit_status_code	op_status	Grocery_delivery_service	Grocery_delivery_status	Online_grocery_pickup_status
X	1.000	0.093	-0.054	0.026	0.026	0.121	0.042	0.044	0.088	0.000	0.075	0.071	0.048
Y	0.093	1.000	-0.177	0.042	0.042	0.092	0.063	0.036	0.037	0.000	0.086	0.000	0.000
objectid	-0.054	-0.177	1.000	0.467	0.467	0.217	0.509	0.021	0.273	0.051	0.062	0.000	0.000
businessunit_number	0.026	0.042	0.467	1.000	1.000	0.511	0.806	0.017	0.385	0.000	0.130	0.000	0.000
bu_num	0.026	0.042	0.467	1.000	1.000	0.511	0.806	0.017	0.385	0.000	0.130	0.000	0.000
businessunit_banner_description	0.121	0.092	0.217	0.511	0.511	1.000	0.999	0.299	0.261	0.000	0.175	0.043	0.032
businessunit_type_description	0.042	0.063	0.509	0.806	0.806	0.999	1.000	0.000	0.045	0.000	0.173	0.012	0.000
businessunit_isstoreopen	0.044	0.036	0.021	0.017	0.017	0.299	0.000	1.000	1.000	0.000	0.000	0.000	0.000
businessunit_status_code	0.088	0.037	0.273	0.385	0.385	0.261	0.045	1.000	1.000	0.000	0.000	0.000	0.000
op_status	0.000	0.000	0.051	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000
Grocery_delivery_service	0.075	0.086	0.062	0.130	0.130	0.175	0.173	0.000	0.000	0.000	1.000	0.315	0.251
Grocery_delivery_status	0.071	0.000	0.000	0.000	0.000	0.043	0.012	0.000	0.000	0.000	0.315	1.000	0.905
Online_grocery_pickup_status	0.048	0.000	0.000	0.000	0.000	0.032	0.000	0.000	0.000	0.000	0.251	0.905	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	X	Y	objectid	businessunit_name	businessunit_number	businessunit_banner_description	businessunit_type_description	businessunit_isstoreopen	facilitydetails_location_locati	facilitydetails_location_loca_1	facilitydetails_location_loca_2	facilitydetails_location_loca_3	facilitydetails_location_loca_8	businessunit_status_code	op_status	Modified_Operating_Hours_	Pharmacy_open_to_public_	Fuel_Station_open_to_public_	bu_num	Grocery_delivery_service	Grocery_delivery_status	Online_grocery_pickup	Online_grocery_pickup_status
0	-94.149054	36.331300	29040	ROGERS, AR	1	WM Supercenter	Retail	True	2110 W WALNUT ST	ROGERS	BENTON	AR	72756-3246	5	Open	NaN	Y	Y	1	Yes	NaN	Yes	Not Available
1	-66.642578	17.997360	29045	PONCE-PR	2026	WM Supercenter	Retail	True	3305 AVE.BARAMAYA SUITE 100	PONCE	PONCE	PR	00728-0000	5	Open	NaN	Y	Y	2026	NaN	NaN	Yes	NaN
2	-97.477003	25.925142	29046	BROWNSVILLE TX	1000	WM Supercenter	Retail	True	2721 BOCA CHICA BLVD	BROWNSVILLE	CAMERON	TX	78521-3501	5	Open	NaN	Y	Y	1000	Yes	NaN	Yes	Available
3	-78.835052	39.624903	29047	LAVALE, MD	2027	WM Supercenter	Retail	True	12500 COUNTRY CLUB MALL RD	LAVALE	ALLEGANY	MD	21502-7553	5	Open	NaN	Y	Y	2027	Yes	Available	Yes	Available
4	-104.664898	38.232316	29048	PUEBLO, CO	1001	WM Supercenter	Retail	True	4080 W NORTHERN AVE	PUEBLO	PUEBLO	CO	81005-3503	5	Open	NaN	Y	Y	1001	Yes	Available	Yes	Available
5	-117.455339	33.937071	29049	RIVERSIDE (S), CA	2028	WM Supercenter	Retail	True	5200 VAN BUREN BLVD	RIVERSIDE	RIVERSIDE	CA	92503-2544	5	Open	NaN	Y	Y	2028	No	NaN	Yes	NaN
6	-87.130708	39.035877	29050	LINTON IN	1002	WM Supercenter	Retail	True	2251 E STATE HIGHWAY 54	LINTON	GREENE	IN	47441-9498	5	Open	NaN	Y	Y	1002	Yes	NaN	Yes	NaN
7	-93.072743	39.767888	29053	BROOKFIELD MO	203	WM Supercenter	Retail	True	937 PARK CIRCLE DR	BROOKFIELD	LINN	MO	64628-7920	5	Open	NaN	Y	Y	203	No	NaN	Yes	NaN
8	-92.479644	42.701631	29056	WAVERLY IA	1005	WM Supercenter	Retail	True	2700 4TH ST SW	WAVERLY	BREMER	IA	50677-4351	5	Open	NaN	Y	Y	1005	Yes	Available	Yes	Available
9	-122.067308	37.604715	29057	UNION CITY, CA	2031	Wal-Mart	Retail	True	30600 DYER ST	UNION CITY	ALAMEDA	CA	94587-1717	2	Open	NaN	Y	Y	2031	Yes	NaN	Yes	NaN

	X	Y	objectid	businessunit_name	businessunit_number	businessunit_banner_description	businessunit_type_description	businessunit_isstoreopen	facilitydetails_location_locati	facilitydetails_location_loca_1	facilitydetails_location_loca_2	facilitydetails_location_loca_3	facilitydetails_location_loca_8	businessunit_status_code	op_status	Modified_Operating_Hours_	Pharmacy_open_to_public_	Fuel_Station_open_to_public_	bu_num	Grocery_delivery_service	Grocery_delivery_status	Online_grocery_pickup	Online_grocery_pickup_status
3606	-82.455718	29.063309	36688	DUNNELLON FL	960	WM Supercenter	Retail	True	11012 NO. WILLIAMS ST	DUNNELLON	MARION	FL	34432-8310	5	Open	NaN	Y	Y	960	Yes	Available	Yes	Available
3607	-90.498285	30.074716	36690	LAPLACE LA	961	WM Supercenter	Retail	True	1616 W AIRLINE HWY	LA PLACE	ST. JOHN THE BAPTIST PARISH	LA	70068-3331	5	Open	NaN	Y	Y	961	No	Available	Yes	Available
3608	-104.523275	37.138728	36693	TRINIDAD CO	962	WM Supercenter	Retail	True	2921 TOUPAL DR	TRINIDAD	LAS ANIMAS	CO	81082-8740	5	Open	NaN	Y	Y	962	Yes	Available	Yes	Available
3609	-97.794862	32.731493	36695	WEATHERFORD TX	963	WM Supercenter	Retail	True	1836 S MAIN ST	WEATHERFORD	PARKER	TX	76086-5506	5	Open	NaN	Y	Y	963	No	Available	Yes	Available
3610	-106.311596	31.682898	36698	EL PASO (S) TX	964	WM Supercenter	Retail	True	9441 ALAMEDA AVE	EL PASO	EL PASO	TX	79907-5601	5	Open	NaN	Y	Y	964	Yes	Available	Yes	Available
3611	-90.508577	44.021024	36700	TOMAH WI	965	WM Supercenter	Retail	True	222 W MCCOY BLVD	TOMAH	MONROE	WI	54660-3291	5	Open	NaN	Y	Y	965	No	NaN	Yes	NaN
3612	-108.561994	37.346568	36702	CORTEZ CO	966	WM Supercenter	Retail	True	1835 E MAIN ST	CORTEZ	MONTEZUMA	CO	81321-3037	5	Open	NaN	Y	Y	966	Yes	NaN	Yes	NaN
3613	-82.631218	28.458397	36704	SPRINGHILL / BROOKSVILLE	967	WM Supercenter	Retail	True	1485 COMMERCIAL WAY	SPRING HILL	HERNANDO	FL	34606-4525	5	Open	NaN	Y	Y	967	Yes	Available	Yes	Available
3614	-81.722251	28.006651	36705	WINTER HAVEN FL	968	WM Supercenter	Retail	True	355 CYPRESS GARDENS BLVD	WINTER HAVEN	POLK	FL	33880-4452	5	Open	NaN	Y	Y	968	Yes	Available	Yes	Available
3615	-89.088697	30.423224	36706	GULFPORT MS	969	WM Supercenter	Retail	True	9350 HIGHWAY 49	GULFPORT	HARRISON	MS	39503-4213	5	Open	NaN	Y	Y	969	No	Not Available	Yes	Available

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Space Separator

Close Punctuation

Open Punctuation

Dash Punctuation

Modifier Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Lowercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common